<!DOCTYPE html>
<html lang="zh">
<head>
    <meta charset="UTF-8">
    <title>拍卖系统</title>
    <style>
    * {
        box-sizing: border-box;
    }
        html , body {
          width: 100%;
          height: 100%;
          margin: 0;
          padding: 0;
        }
        .left {
            display: inline-block;
            width: 25%;
            height: 100%;
            overflow: auto;
            border-right: 1px solid #DFE3EB;
            padding: 10px
        }
        .right {
            display: inline-block;
            width: 75%;
            height: 100%;
            padding: 10px;
            overflow: auto;
        }
        .index {
            font-weight: bold;
            font-size: 25px;
        }
        li {
            list-style: none;
            padding: 5px;
        }
        .first-li {
            font-weight: bold;
            font-size: 20px;
        }
        .second-li {
            font-weight: bold;
        }
        .third-li {
            font-weight: normal;
        }
        .block {
            display: block;
        }
        table {
            width: 100%;
            margin-top: 10px;
            border-color: #E8E8E8;
        }
        .first-tr {
            text-align: center;
        }
        tr:hover {
            background: #ECF9FF;
        }
        td {
            font-weight: normal;
            padding: 5px;
            white-space: nowrap;
        }
        a {
            color: #000000;
            background-color: transparent;
            text-decoration: none;
            outline: none;
            cursor: pointer;
        }
        .group {
            color: green;
        }
        .group-list {
            color: #1890ff;
        }
    </style>
</head>
<body><span class="left"><center class="index">目录</center>
<hr><ul>
<li class="first-li"><a class="group" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-to">1 用户</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-diagrams-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-views-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-views-column-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-column-from" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-to">2 机构</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-diagrams-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-column-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-column-from" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-to">3 拍品</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-diagrams-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-column-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-column-from" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-to">4 平台模块</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-diagrams-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-column-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-column-from" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-to">5 订单模块</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-diagrams-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-views-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-views-column-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-column-from" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul><li class="first-li"><a class="group" id="group-__defaultGroup-from" href="#group-__defaultGroup-to">6 默认分类</a>
<ul><li class="second-li"><a class="group-list" href="#">1 关联关系</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-diagrams-from" href="#group-__defaultGroup-diagrams-to">1 关联关系清单</a></li>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">2 数据表</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-from" href="#group-__defaultGroup-entities-to">1 表清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-entities-column-from" href="#group-__defaultGroup-entities-column-to">2 表列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">3 视图</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-views-from" href="#group-__defaultGroup-views-to">1 视图清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-views-column-from" href="#group-__defaultGroup-views-column-to">2 视图列清单</a>
<ul></ul></li></ul></li></ul><ul><li class="second-li"><a class="group-list" href="#">4 字典</a></li>
<ul><li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-from" href="#group-__defaultGroup-dicts-to">1 字典清单</a></li>
<li class="second-li"><a class="group-list" id="group-__defaultGroup-dicts-column-from" href="#group-__defaultGroup-dicts-column-to">2 字典条目清单</a>
<ul></ul></li></ul></li></ul></ul>
</span><span  class="right"><ul>

<li class="first-li"><a class="group" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-from">1 用户</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-diagrams-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-diagrams-from">1.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-from">1.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>账号表</td><td>as_user</td><td></td></tr>
<tr><td>用户详情表</td><td>as_user_detail</td><td></td></tr>
<tr><td>实名认证表</td><td>as_user_auth</td><td></td></tr>
<tr><td>企业实名认证表</td><td>as_company_auth</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-from">1.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-A39384D8-479F-479E-9182-3CA1CE2DEF80-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-A39384D8-479F-479E-9182-3CA1CE2DEF80-from">1.2.2.1 as_user[账号表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>user_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>account</td><td>用户名</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>phone</td><td>手机号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>password</td><td>密码</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>head_photo</td><td>头像</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>state</td><td>状态（0禁用 | 1 正常 2、待确认 ）</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>credit</td><td>信誉度</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>row_create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>row_update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>type</td><td>类型（0 普通用户|1企业用户|2机构员工）</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-1532364C-7151-4AAD-8612-35B6222B7A87-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-1532364C-7151-4AAD-8612-35B6222B7A87-from">1.2.2.2 as_user_detail[用户详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>user_detail_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>real_name</td><td>用户真实姓名</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>user_address</td><td>用户地址</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>age</td><td>年龄</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>email</td><td>邮箱</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>gender</td><td>性别</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-B13AF501-3979-47C2-A7AD-725EDF1DB997-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-B13AF501-3979-47C2-A7AD-725EDF1DB997-from">1.2.2.3 as_user_auth[实名认证表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>user_auth_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>identity_card</td><td>身份证</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>front_photo</td><td>正面照</td><td></td><td>undefined</td><td></td><td></td></tr>
<tr><td>anti_photo</td><td>反面照</td><td></td><td>undefined</td><td></td><td></td></tr>
<tr><td>brank_card</td><td>银行卡号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>row_create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>row_update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>状态(0未通过 | 1 审核中 | 2 通过 )</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-491D1385-FC4F-4DBF-96F6-6A5B817FE203-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-entities-column-491D1385-FC4F-4DBF-96F6-6A5B817FE203-from">1.2.2.4 as_company_auth[企业实名认证表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>company_auth_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>identity_card</td><td>身份证</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>front_photo</td><td>正面照</td><td></td><td>undefined</td><td></td><td></td></tr>
<tr><td>anti_photo</td><td>反面照</td><td></td><td>undefined</td><td></td><td></td></tr>
<tr><td>row_create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>row_update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>状态(0未通过 | 1 审核中 | 2 通过 )</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>company_name</td><td>企业名称</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>business_photo</td><td>营业执照照片</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-views-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-views-from">1.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-views-column-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-views-column-from">1.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-from">1.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-column-to" href="#group-9A2222E8-0E3B-425A-8330-97E61430057D-dicts-column-from">1.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-from">2 机构</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-diagrams-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-diagrams-from">2.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-from">2.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>机构入驻申请表</td><td>as_organ_join</td><td></td></tr>
<tr><td>机构类型表</td><td>as_organ_type</td><td></td></tr>
<tr><td>机构表</td><td>as_organ</td><td></td></tr>
<tr><td>机构员工表</td><td>as_association</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-from">2.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-0915453B-E73C-4339-9B51-710A9B9C59E8-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-0915453B-E73C-4339-9B51-710A9B9C59E8-from">2.2.2.1 as_organ_join[机构入驻申请表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>organ_detail_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>organ_name</td><td>机构名称</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>cp_card</td><td>法人身份证</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>bl_photo</td><td>营业执照图片</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>address</td><td>地址</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>row_create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>row_update_time</td><td>修改时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>state</td><td>state（0未通过 | 1 审核中 | 2 通过 ）</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>organ_type_id</td><td>机构类型</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>refuse_cause</td><td>拒绝原因</td><td>VARCHAR</td><td>900</td><td></td><td></td></tr>
<tr><td>manage_id</td><td>平台id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>credit_code</td><td>统一社会信用代码</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>register_time</td><td>机构注册时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>business_time</td><td>营业执照有效期</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-5A5054FC-4B21-4E86-A106-BEDA97450204-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-5A5054FC-4B21-4E86-A106-BEDA97450204-from">2.2.2.2 as_organ_type[机构类型表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>organ_type_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>type_name</td><td>类型名字</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-CA36A5BF-7501-412A-8EF1-DBE41361243C-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-CA36A5BF-7501-412A-8EF1-DBE41361243C-from">2.2.2.3 as_organ[机构表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>organ_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>organ_name</td><td>机构名称</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>cp_card</td><td>法人身份证</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>bl_photo</td><td>营业执照图片</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>address</td><td>地址</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>row_create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>row_update_time</td><td>修改时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>organ_detail_id</td><td>机构入驻id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>organ_type</td><td>机构类型</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>credit_code</td><td>统一社会信用代码</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>register_time</td><td>机构注册时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>business_time</td><td>营业执照有效期</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-59B89EAF-AFF2-4507-AF24-CB7C3FB7715A-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-entities-column-59B89EAF-AFF2-4507-AF24-CB7C3FB7715A-from">2.2.2.4 as_association[机构员工表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>organ_id</td><td>机构id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>status</td><td>状态(0、正常 1、离职 2、禁用)</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>creata_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-from">2.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-column-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-views-column-from">2.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-from">2.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-column-to" href="#group-4F2B3162-0485-4C0D-A1C3-3A95A9D3F033-dicts-column-from">2.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-from">3 拍品</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-diagrams-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-diagrams-from">3.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-from">3.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>拍品类型</td><td>as_lot_type</td><td></td></tr>
<tr><td>拍品表</td><td>as_lot</td><td></td></tr>
<tr><td>拍卖室 [竞拍信息表]</td><td>as_lot_room</td><td></td></tr>
<tr><td>出价记录表</td><td>as_lot_big_record</td><td></td></tr>
<tr><td>房产拍卖表</td><td>as_lot_house</td><td></td></tr>
<tr><td>图片详情表</td><td>as_lot_image</td><td></td></tr>
<tr><td>中间表</td><td>as_user_lot_room</td><td></td></tr>
<tr><td>专场表</td><td>as_special_performance</td><td></td></tr>
<tr><td>竞拍报名表</td><td>as_lot_bidding_apply</td><td></td></tr>
<tr><td>退款记录表</td><td>as_lot_out_price</td><td></td></tr>
<tr><td>竞拍收藏表</td><td>as_lot_collect</td><td></td></tr>
<tr><td>竞拍提醒表</td><td>as_bidding_remind</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-from">3.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-61393B5E-E52A-457F-A2FF-04A8DC9FCD80-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-61393B5E-E52A-457F-A2FF-04A8DC9FCD80-from">3.2.2.1 as_lot_type[拍品类型]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>lot_type_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_type_name</td><td>拍品类型名称</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>organ_type_id</td><td>机构类型id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-B152AE48-49F4-482B-A570-3D061EB69962-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-B152AE48-49F4-482B-A570-3D061EB69962-from">3.2.2.2 as_lot[拍品表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>lot_info_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_name</td><td>拍品名字</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>lot_type_id</td><td>拍品类型</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_organ_id</td><td>属于谁卖的（机构名字）</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_start_time</td><td>竞拍开始时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>lot_decrible</td><td>拍品描述</td><td>VARCHAR</td><td>900</td><td></td><td></td></tr>
<tr><td>lot_num</td><td>拍品数量</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_status</td><td>状态 0 待审核 | 1 审核中 | 2审核通过 | 3 待竞拍 | 4竞拍中 | 5 代发货  | 6、流拍 |7、悔拍</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>manage_id</td><td>平台id</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>lot_image</td><td>拍品图片</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>lot_no</td><td>拍品编号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-DC5E9416-8B79-489B-ABBF-0F8A7017186D-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-DC5E9416-8B79-489B-ABBF-0F8A7017186D-from">3.2.2.3 as_lot_room[拍卖室 [竞拍信息表]]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>lot_room_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_room_start_time</td><td>竞拍开始时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_end_time</td><td>竞拍结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_start_price</td><td>起拍价</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>lot_id</td><td>拍品id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>deposit</td><td>保证金</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>markup_margin</td><td>加价幅度</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>service_price</td><td>拍卖服务费</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>lot_range</td><td>拍卖周期</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>delay_range</td><td>延迟周期</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_second</td><td>拍卖次数</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>notice</td><td>竞卖公告</td><td>VARCHAR</td><td>900</td><td></td><td></td></tr>
<tr><td>require</td><td>规定</td><td>VARCHAR</td><td>900</td><td></td><td></td></tr>
<tr><td>agreement</td><td>竞卖协议</td><td>VARCHAR</td><td>900</td><td></td><td></td></tr>
<tr><td>lot_status</td><td>状态(0、待竞拍、1、竞拍中 2、流拍   3、竞拍成功 4、逾期 5、未逾期 6、支付中 7、已支付)</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>special_performance_id</td><td>专场id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_type</td><td>拍卖室类型（单、专）（SINGLE | DOUBLE）</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-06F071F5-49C5-409D-BB56-321968A14C0F-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-06F071F5-49C5-409D-BB56-321968A14C0F-from">3.2.2.4 as_lot_big_record[出价记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>big_record_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>出价人</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>price</td><td>出价的价钱</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>status</td><td>状态(0、领先 1、淘汰 2、出价成功 3、出价失败)</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>price_time</td><td>出价时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_type</td><td>拍卖室类型（单、专）（SINGLE | DOUBLE）</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-B8A30146-4949-4EAB-9C6C-DED97ABAEF23-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-B8A30146-4949-4EAB-9C6C-DED97ABAEF23-from">3.2.2.5 as_lot_house[房产拍卖表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_id</td><td>拍品id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>area</td><td>面积</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>adress</td><td>地址</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>longitude</td><td>经度</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>latitude</td><td>纬度</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-D1E510DC-76B0-41D0-A7C2-B00365072A49-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-D1E510DC-76B0-41D0-A7C2-B00365072A49-from">3.2.2.6 as_lot_image[图片详情表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_images</td><td>拍品图片</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>lot_id</td><td>拍品id</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-00F2E86D-C556-4723-B7FA-3F8DFCC21CBA-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-00F2E86D-C556-4723-B7FA-3F8DFCC21CBA-from">3.2.2.7 as_user_lot_room[中间表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_number</td><td>拍品牌号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-FC0AAC80-86E8-4CF0-B6CF-C18C8E9D9B2A-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-FC0AAC80-86E8-4CF0-B6CF-C18C8E9D9B2A-from">3.2.2.8 as_special_performance[专场表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>special_performance_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>organ_id</td><td>机构id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>price</td><td>保证金</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>start_time</td><td>开始时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>end_time</td><td>结束时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>price_type</td><td>保证金类型</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>offer_record</td><td>拍卖次数</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_count</td><td>拍品数</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_count</td><td>报名人数</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-820F021D-269E-4046-95FE-B9484A206D59-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-820F021D-269E-4046-95FE-B9484A206D59-from">3.2.2.9 as_lot_bidding_apply[竞拍报名表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>price</td><td>保证金</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>create_time</td><td>缴纳时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>special_performance_id</td><td>专场id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>status</td><td>保证金状态(0、未返还 1、已返还)</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
<tr><td>lot_room_type</td><td>拍卖室类型（单、专）（SINGLE | DOUBLE）</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-95EC2789-9B90-4AF6-9109-C73B6D205FF4-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-95EC2789-9B90-4AF6-9109-C73B6D205FF4-from">3.2.2.10 as_lot_out_price[退款记录表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>price</td><td>退款金额</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>out_time</td><td>退款时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>special_performance_id</td><td>专场id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_type</td><td>拍卖室类型（单、专）（SINGLE | DOUBLE）</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-3C05EF3E-6A5C-48AF-95F6-171DDA396B42-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-3C05EF3E-6A5C-48AF-95F6-171DDA396B42-from">3.2.2.11 as_lot_collect[竞拍收藏表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_id</td><td>竞拍室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-60DCDF8D-15C9-4CC1-B76B-7384AFEBC435-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-entities-column-60DCDF8D-15C9-4CC1-B76B-7384AFEBC435-from">3.2.2.12 as_bidding_remind[竞拍提醒表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>status</td><td>状态(0、未提醒 1、已提醒)</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>lot_room_id</td><td>竞拍室</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-from">3.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-column-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-views-column-from">3.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-from">3.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-column-to" href="#group-F5E67558-29F7-4B2A-95BE-DF4CDD3D0A49-dicts-column-from">3.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-from">4 平台模块</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-diagrams-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-diagrams-from">4.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-from">4.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>服务费表</td><td>manage_deposit</td><td></td></tr>
<tr><td>平台账户表</td><td>manage_user</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-from">4.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-CBF46041-A900-402B-8906-256501FDB508-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-CBF46041-A900-402B-8906-256501FDB508-from">4.2.2.1 manage_deposit[服务费表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>deposit_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>lot_room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>price</td><td>收取的金额</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>create_time</td><td>收取的时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>service_ratio</td><td>服务比例</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>lot_price</td><td>拍出价格</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>user_id</td><td>支付方</td><td>INT</td><td></td><td></td><td></td></tr>
</table>
</li>

 <li><a class="block" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-4BBE82EF-3924-4795-A38D-57C4F54C2DFA-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-entities-column-4BBE82EF-3924-4795-A38D-57C4F54C2DFA-from">4.2.2.2 manage_user[平台账户表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>manage_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>manage_name</td><td>账号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>manage_password</td><td>密码</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>manage_phone</td><td>电话</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>create</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>head_imge</td><td>头像</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>status</td><td>状态（0禁用|1正常）</td><td>VARCHAR</td><td>255</td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-from">4.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-column-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-views-column-from">4.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-from">4.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-column-to" href="#group-F0637A7D-CF74-461B-8913-3D08130BCC0D-dicts-column-from">4.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-from">5 订单模块</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-diagrams-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-diagrams-from">5.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-from">5.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
<tr><td>拍品支付订单表</td><td>as_pay_order</td><td></td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-from">5.2.2 表列清单</a>

<ul style="padding: 0"> <li><a class="block" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-99058545-5D62-453C-A3F0-E9B33D3AD601-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-entities-column-99058545-5D62-453C-A3F0-E9B33D3AD601-from">5.2.2.1 as_pay_order[拍品支付订单表]</a>

<table border="1" cellspacing="0">
<tr class="first-tr"><td>代码</td><td>名称</td><td>数据类型</td><td>长度</td><td>主键</td><td>备注</td></tr>
<tr><td>order_id</td><td></td><td>INT</td><td></td><td>√</td><td></td></tr>
<tr><td>order_num</td><td>订单号</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>lot_id</td><td>拍品id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>room_id</td><td>拍卖室id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>price</td><td>成交价格</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>row_pay_time</td><td>订单支付时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>status</td><td>0 待支付 | 1 支付中 | 2 支付成功 | 支付失败</td><td>VARCHAR</td><td>undefined</td><td></td><td></td></tr>
<tr><td>user_id</td><td>用户id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>organ_id</td><td>机构id</td><td>INT</td><td></td><td></td><td></td></tr>
<tr><td>pay_price</td><td>付款金额</td><td>DECIMAL</td><td>24</td><td></td><td></td></tr>
<tr><td>create_time</td><td>创建时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
<tr><td>update_time</td><td>更新时间</td><td>DATETIME</td><td></td><td></td><td></td></tr>
</table>
</li>

</li></ul><hr></li><li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-views-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-views-from">5.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-views-column-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-views-column-from">5.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-from">5.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-column-to" href="#group-174AA288-E48C-4622-A259-FAFF36FB5772-dicts-column-from">5.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li><li class="first-li"><a class="group" id="group-__defaultGroup-to" href="#group-__defaultGroup-from">6 默认分类</a><ul>
<li class="second-li"><a class="group-list" class="block" id="group-__defaultGroup-diagrams-to" href="#group-__defaultGroup-diagrams-from">6.1 关联关系清单</a>
<span>该模块未配置关系图</span>
</li><hr>
<li><a class="group-list" id="group-__defaultGroup-entities-to" href="#group-__defaultGroup-entities-from">6.2.1  表清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-entities-column-to" href="#group-__defaultGroup-entities-column-from">6.2.2 表列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-views-to" href="#group-__defaultGroup-views-from">6.3.1  视图清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-views-column-to" href="#group-__defaultGroup-views-column-from">6.3.2 视图列清单</a>

<ul style="padding: 0"></li></ul><hr></li><li><a class="group-list" id="group-__defaultGroup-dicts-to" href="#group-__defaultGroup-dicts-from">6.4.1  字典清单</a>



<table border="1" cellspacing="0">
<tr class="first-tr"><td>名称</td><td>代码</td><td>备注</td></tr>
</table>
</li><hr>

<li><a class="group-list" id="group-__defaultGroup-dicts-column-to" href="#group-__defaultGroup-dicts-column-from">6.4.2 字典条目清单</a>

<ul style="padding: 0"></li></ul><hr></li></ul></li></ul><hr></li></ul></span></body>
</html>